SyServiceProcess

Logical Entity Name | SyServiceProcess
Default Table Name | SyServiceProcess
Physical Only | NO
Owner | dbo
Definition |
Note |

SyServiceProcess Columns

ColumnName | Domain | Datatype | NULL | Definition
SyServiceProcessId |  | int | NO |
SyServiceProcessTypeId |  | int | NO |
Code |  | char(8) | NO |
Descrip |  | varchar(50) | NO |
Active |  | bit | NO |
Module |  | varchar(50) | NO |
WebServiceEndPoint |  | nvarchar(1000) | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
ProcessInfoType |  | int | NO |
IsExceptionMgmtReady |  | bit | NO |

SyServiceProcess Primary and Unique Keys

Key Name | Key Type | Keys
Uk_SyServiceProcessCode | Index | Code
Pk_SyServiceProcess_SyServiceProcessID | PrimaryKey | SyServiceProcessId

SyServiceProcess Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyServiceProcessType | Non-Identifying | One To Zero or More | FK_SyServiceProcessSyServiceProcessTypeId_SyServiceProcessTypeSyServiceProcessTypeId |  |  | SyServiceProcessTypeId | NO | YES
SyStaff | Non-Identifying | One To Zero or More | Fk_SyServiceProcessUserID_SyStaffSyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
SyAutomatedProcessActivation | Non-Identifying | One To Zero or More | FK_SyAutomatedProcessActivationSyServiceProcessID_SyServiceProcessSyServiceProcessID |  |  |  | NO | YES
SyEventSinkSubscription | Non-Identifying | One To Zero or More | FK_SyEventSinkSubscriptionSyServiceProcessId_SyServiceProcessSyServiceProcessId |  |  |  | NO | YES
SyServiceExceptionTemplate | Non-Identifying | One To Zero or More | FK_SyServiceExceptionTemplateSyServiceProcessId_SyServiceProcessSyServiceProcessId |  |  |  | NO | YES
SyServiceProcessExportImportMapping | Non-Identifying | One To Zero or More | FK_SyServiceProcessExportImportMapping_SyServiceProcess_SyServiceProcessID_Exp |  |  |  | NO | YES
SyServiceProcessExportImportMapping | Non-Identifying | One To Zero or More | FK_SyServiceProcessExportImportMapping_SyServiceProcess_SyServiceProcessID_Imp |  |  |  | NO | YES
SyServiceProcessExportMaster | Non-Identifying | Zero or One to Zero or More | FK_SyServiceProcessExportMaster_SyServiceProcessID_SyServiceProcess_SyServiceProcessId |  |  |  | NO | YES
SyServiceProcessImportMaster | Non-Identifying | Zero or One to Zero or More | FK_SyServiceProcessImportMasterSyServiceProcessID_SyServiceProcessSyServiceProcessId |  |  |  | NO | YES
SyServiceProcessMapping | Non-Identifying | One To Zero or More | FK_SyServiceProcessMappingSyServiceProcessID_SyServiceProcessSyServiceProcessID |  |  |  | NO | YES
SyServiceProcessSubscription | Non-Identifying | One To Zero or More | Fk_SyServiceProcessSubscriptionSyServiceProcessID_SyServiceProcessSyServiceProcessID |  |  |  | NO | YES
SyServiceRequest | Non-Identifying | One To Zero or More | FK_SyServiceRequestSyServiceProcessId_SyServiceProcessSyServiceProcessId |  |  |  | NO | YES
SyServiceStarRequestQueue | Non-Identifying | One To Zero or More | FK_SyServiceStarRequestQueueSyServiceProcessId_SyServiceProcessSyServiceProcessId |  |  |  | NO | YES
SyServiceSubscriptionExceptionRoutingRelationship | Non-Identifying | One To Zero or More | FK_SyServiceSubscriptionExceptionRoutingRelationshipSyServiceProcessId_SyServiceProcessSyServiceProcessId |  |  |  | NO | YES
SyServiceSubscriptionNotificationRelationship | Non-Identifying | One To Zero or More | FK_SyServiceSubscriptionNotificationRelationshipSyServiceProcessId_SyServiceProcessSyServiceProcessId |  |  |  | NO | YES

SyServiceProcess Check Constraints

Check Constraint Name | CheckConstraint

SyServiceProcess Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SyServiceProcess Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.BusinessProcess | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyServiceProcess | NO |  |  |

SyServiceProcess Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Service
Physical (Microsoft SQL Server) | System

SyServiceProcess Data Movement Rules

Name | Type | Rule Text/Value